Q Part 1 - Using Excel Formulas Before using Solver, consider making a few changes to your food log table. For each food item, for which you previously constructed the two-variable data tables, add rows with portion names and calories per portion that correspond to the data tables. Enter zeros in the portion amount column for these rows. Adjust the formula in the Total per day cell to include data in newly added rows. Note: Make use of the SUMPRODUCT formula. Part 2 - Solver Use the following guidelines to set up the constraints: 1. All portion amounts must be whole numbers. Negative portion amounts do not make sense. 2. For food items with alternative portion sizes, the approach is to reduce the portion sizes and to adjust the portion amounts. Hence, set the amounts of currently used portions to be smaller or equal to the value of one less the existing value, and the amounts of alternatives (initially, they are zeros) to be greater or equal to 1. 3. For food items with no alternative portion sizes, there is a choice of either reducing the portion amounts or eliminating this food item from the log. However, when choosing to remove any food item, consider the effects this action would have on balancing the diet. For example, if a major part of the dinner consists of 1 portion of fried chicken, it would not be a good idea to remove this item. In other words, be sure there are adequate inputs for breakfast, lunch, and dinner. The amount of snacks throughout the day is up to you. 4. The target cell must be non-negative. 5. The introduction of integer constraints may complicate the process of solving the problem greatly. To avoid lengthy delays, suggest setting Max Time option to the default value of 100 sec. Save the current Solver model. Run Solver to optimize the value in the target cell by adjusting the portion sizes. Part 3 - Answer Report Create the Answer report. In a document, using 10-12 sentences, explain the outcomes presented in the Answer report. Submit both the Excel workbook and a Word document for this activity. ________________________________________ Save your assignments using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters. Outcomes: The solver add in is a Excels add in program which is used to determine desired outcome by changing or adding different assumptions in a table. It is what if analysis which is particularly useful when we are trying to gain desired outcome.